DbForge Studio for MySQL

dbForge Studio for MySQL

Developer(s)	Devart
Stable release	5.0 / 19/04/2011
Development status	Active
Written in	C#
Operating system	Microsoft Windows
Size	28,14MB
Available in	English, Russian
Type	RDBMS
License	Commercial, Non-commercial, and Free
Website	www.devart.com/dbforge/mysql/studio

dbForge Studio for MySQL is a software application created by Devart for developing and administrating the popular Relational Database Management System (RDBMS) MySQL.

Contents 1 Editions (licenses) 2 History 3 Functionality 4 Current version 5 See also 6 References 7 External links

Editions (licenses)

dbForge Studio for MySQL has three editions: Express, Standard, and Professional.

Express is a free software, which provides basic functionality for working with schema objects, user accounts, and SQL scripts.

Standard includes essential tools for database developers, such as a debugger, a Query Builder, code templates, object search, various export and maintenance wizards.

Professional is a full-featured software for database projects, comparing schema and project data, debugging stored procedures and scripts, creating complex queries, etc.

History

The first version was released on 12 April 2005 under the name "MyDeveloper Studio".

Through 3 years of development the product has raised up to the version 3.0 (released on 01-August-2008), and got a new name - "dbForge Studio for MySQL" as well as a lot of new features and improvements^[1].

Version 4.0 saw release on 10 February 2010. The improved version 4.50 was released on 21 June 2010.

On 19 April 2011 the product version 5.0 was released and is the most current as of now^[2].

Functionality

dbForge Studio for MySQL has got both standard features of most database tools and unique functionality.

Main features of dbForge Studio for MySQL, v5.0 include:

• Administration and Maintenance tools

- A comprehensive Security Manager to administer user accounts and privileges;

- Special MySQL administration tools boosting MySQL server maintenance;

- Backup and restore wizards supporting large databases and enabling users to back up and restore schemas or data only in addition to full backups;

- Advanced search tools allowing to find a required database object by any fragment of its CREATE statement, as well as find a data fragment in one or several tables;

- Service control to administrate several MySQL servers on different computers.

• Query Builder - provides visual creation and management of queries and complex sub-queries in a diagram.

• Query Profiler - a tool for database developers that offers visual query profiling and MySQL query optimization, achieved through comparison of profiling results.

• Reporting and Analysis tools provide extended capabilities to prepare data reports with MySQL reporting tool and conversion of row data to informative pivot tables.

• Multi-format data export to 10 widely-used data formats – CSV, XML, Text, XLS (MS Excel), PDF, DBF, HTML, RTF, MDB (MS Access), ODBC.

• Multi-format data import from 8 widely-used data formats – CSV, XML, Text, XLS (MS Excel), XLSX (MS Excel 2007/2010), DBF, MDB (MS Access), ODBC.

• Database Designer - a visual database design and editing tool for MySQL. Provides the complete picture of all the database objects and their properties, as well as foreign key relations between tables on a MySQL database diagram. Enables easy execution of stored routines.

• Code Debugger – a dedicated debugger for MySQL. Uses database server as an engine for checking user created SQL scripts and automates debugging of stored procedures, functions, and triggers, giving full control over code execution.

• SQL code editor - includes context-sensitive code completion, automatic SQL syntax check and highlighting, SQL formatter wizard, code templates and definitions for schema objects.

• Database synchronization – several synchronization ways provide display of differences, grouping and filtering as well as MySQL schema and data comparison with MySQL sync tools.

• Database projects for MySQL server - include the capability to integrate various SQL and script files into a single project, group them into folders, and manage in one place. You can build your project to a single or several script files and deploy them on the server.

Current version

The latest version of dbForge Studio for MySQL is 5.0. The following features were introduced in this version:

• Full compatibility with MySQL server 5.5;
• Master-Detail Browser;
• Object dependency tree;
• Enhanced Data Editor;
• Improved Security Manager;
• Data Export and Import improvements;
• Object Viewer;
• Revised start page;
• New skins.

See also

• Comparison of database tools
• Devart (company)

References

1. ^ dbForge Studio for MySQL release news, Devart
2. ^ dbForge Studio for MySQL history, Devart

External links

• dbForge Studio for MySQL website
• Official Devart website
• Devart blogs
• Devart forums
• dbForge Studio for MySQL page at MySQL partners portal
• Codeproject.com press room - About dbForge Studio for MySQL 3.50